home *** CD-ROM | disk | FTP | other *** search
Text File | 1994-06-29 | 46.9 KB | 1,698 lines |
- * This program reads in raw data from remax in the specified format
- * It replaces the remax.ap file and awk
-
- new = FCREATE("RMXDTA.TXT")
- bio = FCREATE("bioinfo.txt")
- handle = FOPEN("NAME.dat")
- *
- *IF handle < 0
- * DEFINE WINDOW alert FROM 7,17 TO 12,60 DOUBLE COLOR SCHEME 7
-
- * DO CASE
- * CASE FERROR() = 4
- * reason = 'Too many files Open'
- * CASE FERROR() = 5
- * reason = 'Access Denied'
- * CASE FERROR() = 8
- * reason = 'Out of Memory'
- * CASE FERROR() = 31
- * reason = 'GENERAL FAILURE'
- * ENDCASE
-
- * CANCEL
-
- * ENDIF
-
- Count = 0
-
- DO WHILE Count <= 15 && NOT FEOF(handle)
-
- Region = FREAD(handle, 2)
- Office = FREAD(handle, 3)
- Number = FREAD(handle, 3)
- Unique = FREAD(handle,12)
- Name = FREAD(handle, 30)
- Nick = FREAD(handle, 20)
- Title = FREAD(handle, 2)
- Posistion = FREAD(handle, 30)
- Spec1 = FREAD(handle, 3)
- Spec2 = FREAD(handle, 3)
- Lang1 = FREAD(handle, 20)
- Lang2 = FREAD(handle, 20)
- Lang3 = FREAD(handle, 20)
- License = FREAD(handle, 4)
- Join = FREAD(handle, 4)
- Sales = FREAD(handle, 6)
- Desig1 = FREAD(handle, 6)
- Desig2 = FREAD(handle, 6)
- Desig3 = FREAD(handle, 6)
- Desig4 = FREAD(handle, 6)
- Desig5 = FREAD(handle, 6)
- Desig6 = FREAD(handle, 6)
- Club = FREAD(handle, 4)
- ROF = FREAD(handle, 12)
- Comm1 = UPPER(FREAD(handle, 1))
- Comm2 = UPPER(FREAD(handle, 1))
- Comm3 = UPPER(FREAD(handle, 1))
- Comm4 = UPPER(FREAD(handle, 1))
- Comm5 = UPPER(FREAD(handle, 1))
- skip = FSEEK(handle, 5, 1)
- OffName = FREAD(handle, 30)
- OffAdd1 = FREAD(handle, 30)
- OffAdd2 = FREAD(handle, 30)
- City = FREAD(handle, 17)
- State = FREAD(handle, 2)
- Zip = FREAD(handle, 10)
- Country = FREAD(handle, 20)
- Phone1 = FREAD(handle, 12)
- Phone2 = FREAD(handle, 12)
- Phone3 = FREAD(handle, 12)
- Phone4 = FREAD(handle, 12)
- FAX = FREAD(handle, 12)
- Service1 = FREAD(handle, 20)
- Service2 = FREAD(handle, 20)
- Service3 = FREAD(handle, 20)
- Service4 = FREAD(handle, 20)
- Open = FREAD(handle, 6)
- ADI = FREAD(handle, 20)
- Page = FREAD(handle, 4)
- Coor = FREAD(handle, 2)
- OffType = FREAD(handle, 2)
- CityOver = FREAD(handle, 17)
- RosterSta = FREAD(handle, 30)
- Rams = FREAD(handle, 15)
- Achiev = FREAD(handle, 20)
- COMPUSERV = FREAD(handle, 17)
-
- * START READING BIO INFO
-
- PhoneLoc = FREAD(handle, 12)
- HomePhone = FREAD(handle, 12)
- AgntFax = FREAD(handle, 12)
- AgntPager = FREAD(handle, 12)
- AgntMobile = FREAD(handle, 12)
- CIVIC1 = UPPER(FREAD(handle, 4))
- CIVIC2 = UPPER(FREAD(handle, 4))
- CIVIC3 = UPPER(FREAD(handle, 4))
- HOBBY1 = UPPER(FREAD(handle, 4))
- HOBBY2 = UPPER(FREAD(handle, 4))
- HOBBY3 = UPPER(FREAD(handle, 4))
- MEMBER1 = FREAD(handle, 4)
- MEMBER2 = FREAD(handle, 4)
- MEMBER3 = FREAD(handle, 4)
- Service1 = FREAD(handle, 20)
- Service2 = FREAD(handle, 20)
- Service3 = FREAD(handle, 20)
- Service4 = FREAD(handle, 20)
- Service5 = FREAD(handle, 20)
- Education = FREAD(handle, 15)
- Desig1 = FREAD(handle, 10)
- Desig2 = FREAD(handle, 10)
- Desig3 = FREAD(handle, 10)
- Career = FREAD(handle, 40)
- Price_fr = FREAD(handle, 12)
- Price_to = FREAD(handle, 12)
- Pref = FREAD(handle, 1)
- Referal1 = FREAD(handle, 1)
- Referal2 = FREAD(handle, 1)
- Referal3 = FREAD(handle, 1)
- Referal4 = FREAD(handle, 1)
- ERCPaper = FREAD(handle, 1)
- Welcomekit = FREAD(handle, 1)
- Relocations = FREAD(handle, 5)
- Picture = FREAD(handle, 1)
- EntryDate = FREAD(handle, 6)
- BioSubs = FREAD(handle, 10)
- Info = FGETS(handle, 480)
-
- * START WRITING TO "new"
-
- =FWRITE(new, Region)
- =FWRITE(new, ',')
- =FWRITE(new, Office)
- =FWRITE(new, ',')
- =FWRITE(new, Number)
- =FWRITE(new, ',')
- =FWRITE(new, Unique)
- =FWRITE(new, ',"')
- =FWRITE(new, TRIM(Name))
- =FWRITE(new, '",')
-
- IF NOT EMPTY(TRIM(Nick))
- =FWRITE(new, '"'+TRIM(Nick)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Title))
- =FWRITE(new, '"'+TRIM(Title)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Posistion))
- =FWRITE(new, '"'+TRIM(Posistion)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Spec1))
- =FWRITE(new, '"'+TRIM(Spec1)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Spec2))
- =FWRITE(new, '"'+TRIM(Spec2)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Lang1))
- =FWRITE(new, '"'+TRIM(Lang1)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Lang2))
- =FWRITE(new, '"'+TRIM(Lang2)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Lang3))
- =FWRITE(new, '"'+TRIM(Lang3)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(License))
- =FWRITE(new, TRIM(License)+',')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Join))
- =FWRITE(new, TRIM(Join)+',')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Sales))
- =FWRITE(new, TRIM(Sales)+',')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig1))
- =FWRITE(new, '"'+TRIM(Desig1)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig1))
- =FWRITE(new, '"'+TRIM(Desig1)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig2))
- =FWRITE(new, '"'+TRIM(Desig2)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig3))
- =FWRITE(new, '"'+TRIM(Desig3)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig4))
- =FWRITE(new, '"'+TRIM(Desig4)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig5))
- =FWRITE(new, '"'+TRIM(Desig5)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig6))
- =FWRITE(new, '"'+TRIM(Desig6)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Club))
- =FWRITE(new, '"'+TRIM(Club)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(ROF))
- =FWRITE(new, '"'+TRIM(ROF)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Comm1))
- DO CASE
- CASE Comm1 == 'A'
- =FWRITE(new, '"Apartment Buildings (under 100 units)",')
- CASE Comm1 == 'B'
- =FWRITE(new, '"Apartment Buildings (over 100 units)",')
- CASE Comm1 == 'C'
- =FWRITE(new, '"Build to Suit/Leaseback (under 100 units)",')
- CASE Comm1 == 'D'
- =FWRITE(new, '"Business Opportunities",')
- CASE Comm1 == 'E'
- =FWRITE(new, '"Condo Conversions",')
- CASE Comm1 == 'F'
- =FWRITE(new, '"Development",')
- CASE Comm1 == 'G'
- =FWRITE(new, '"Exchanging",')
- CASE Comm1 == 'H'
- =FWRITE(new, '"Farm and Land",')
- CASE Comm1 == 'I'
- =FWRITE(new, '"Foreign Investment Property",')
- CASE Comm1 == 'J'
- =FWRITE(new, '"General Commercial",')
- CASE Comm1 == 'K'
- =FWRITE(new, '"Health Care Faculties",')
- CASE Comm1 == 'L'
- =FWRITE(new, '"Hotels/Motels",')
- CASE Comm1 == 'M'
- =FWRITE(new, '"Industrial Properties/Warehouse",')
- CASE Comm1 == 'N'
- =FWRITE(new, '"Leasing",')
- CASE Comm1 == 'O'
- =FWRITE(new, '"Mobile Home Parks",')
- CASE Comm1 == 'P'
- =FWRITE(new, '"Office Buildings (under 100,000 S.F.)",')
- CASE Comm1 == 'Q'
- =FWRITE(new, '"Office Buildings (over 100,000 S.F.)",')
- CASE Comm1 == 'R'
- =FWRITE(new, '"Other",')
- CASE Comm1 == 'S'
- =FWRITE(new, '"Restaurant",')
- CASE Comm1 == 'T'
- =FWRITE(new, '"Retirement Properties/Communities",')
- CASE Comm1 == 'U'
- =FWRITE(new, '"Shopping Centers (under 100,000 S.F.)",')
- CASE Comm1 == 'V'
- =FWRITE(new, '"Shopping Centers (over 100,000 S.F.)",')
- CASE Comm1 == 'W'
- =FWRITE(new, '"Vacant Land (Commercial/Industrial Sites)",')
- CASE Comm1 == 'X'
- =FWRITE(new, '"Vacant Land (Residential Sites)",')
- CASE Comm1 == 'Y'
- =FWRITE(new, '"Real Estate Owned (REO)",')
- OTHERWISE
- =FWRITE(new, ',')
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(Comm2))
- DO CASE
- CASE Comm2 == 'A'
- =FWRITE(new, '"Apartment Buildings (under 100 units)",')
- CASE Comm2 == 'B'
- =FWRITE(new, '"Apartment Buildings (over 100 units)",')
- CASE Comm2 == 'C'
- =FWRITE(new, '"Build to Suit/Leaseback (under 100 units)",')
- CASE Comm2 == 'D'
- =FWRITE(new, '"Business Opportunities",')
- CASE Comm2 == 'E'
- =FWRITE(new, '"Condo Conversions",')
- CASE Comm2 == 'F'
- =FWRITE(new, '"Development",')
- CASE Comm2 == 'G'
- =FWRITE(new, '"Exchanging",')
- CASE Comm2 == 'H'
- =FWRITE(new, '"Farm and Land",')
- CASE Comm2 == 'I'
- =FWRITE(new, '"Foreign Investment Property",')
- CASE Comm2 == 'J'
- =FWRITE(new, '"General Commercial",')
- CASE Comm2 == 'K'
- =FWRITE(new, '"Health Care Faculties",')
- CASE Comm2 == 'L'
- =FWRITE(new, '"Hotels/Motels",')
- CASE Comm2 == 'M'
- =FWRITE(new, '"Industrial Properties/Warehouse",')
- CASE Comm2 == 'N'
- =FWRITE(new, '"Leasing",')
- CASE Comm2 == 'O'
- =FWRITE(new, '"Mobile Home Parks",')
- CASE Comm2 == 'P'
- =FWRITE(new, '"Office Buildings (under 100,000 S.F.)",')
- CASE Comm2 == 'Q'
- =FWRITE(new, '"Office Buildings (over 100,000 S.F.)",')
- CASE Comm2 == 'R'
- =FWRITE(new, '"Other",')
- CASE Comm2 == 'S'
- =FWRITE(new, '"Restaurant",')
- CASE Comm2 == 'T'
- =FWRITE(new, '"Retirement Properties/Communities",')
- CASE Comm2 == 'U'
- =FWRITE(new, '"Shopping Centers (under 100,000 S.F.)",')
- CASE Comm2 == 'V'
- =FWRITE(new, '"Shopping Centers (over 100,000 S.F.)",')
- CASE Comm2 == 'W'
- =FWRITE(new, '"Vacant Land (Commercial/Industrial Sites)",')
- CASE Comm2 == 'X'
- =FWRITE(new, '"Vacant Land (Residential Sites)",')
- CASE Comm2 == 'Y'
- =FWRITE(new, '"Real Estate Owned (REO)",')
- OTHERWISE
- =FWRITE(new, ',')
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(Comm3))
- DO CASE
- CASE Comm3 == 'A'
- =FWRITE(new, '"Apartment Buildings (under 100 units)",')
- CASE Comm3 == 'B'
- =FWRITE(new, '"Apartment Buildings (over 100 units)",')
- CASE Comm3 == 'C'
- =FWRITE(new, '"Build to Suit/Leaseback (under 100 units)",')
- CASE Comm3 == 'D'
- =FWRITE(new, '"Business Opportunities",')
- CASE Comm3 == 'E'
- =FWRITE(new, '"Condo Conversions",')
- CASE Comm3 == 'F'
- =FWRITE(new, '"Development",')
- CASE Comm3 == 'G'
- =FWRITE(new, '"Exchanging",')
- CASE Comm3 == 'H'
- =FWRITE(new, '"Farm and Land",')
- CASE Comm3 == 'I'
- =FWRITE(new, '"Foreign Investment Property",')
- CASE Comm3 == 'J'
- =FWRITE(new, '"General Commercial",')
- CASE Comm3 == 'K'
- =FWRITE(new, '"Health Care Faculties",')
- CASE Comm3 == 'L'
- =FWRITE(new, '"Hotels/Motels",')
- CASE Comm3 == 'M'
- =FWRITE(new, '"Industrial Properties/Warehouse",')
- CASE Comm3 == 'N'
- =FWRITE(new, '"Leasing",')
- CASE Comm3 == 'O'
- =FWRITE(new, '"Mobile Home Parks",')
- CASE Comm3 == 'P'
- =FWRITE(new, '"Office Buildings (under 100,000 S.F.)",')
- CASE Comm3 == 'Q'
- =FWRITE(new, '"Office Buildings (over 100,000 S.F.)",')
- CASE Comm3 == 'R'
- =FWRITE(new, '"Other",')
- CASE Comm3 == 'S'
- =FWRITE(new, '"Restaurant",')
- CASE Comm3 == 'T'
- =FWRITE(new, '"Retirement Properties/Communities",')
- CASE Comm3 == 'U'
- =FWRITE(new, '"Shopping Centers (under 100,000 S.F.)",')
- CASE Comm3 == 'V'
- =FWRITE(new, '"Shopping Centers (over 100,000 S.F.)",')
- CASE Comm3 == 'W'
- =FWRITE(new, '"Vacant Land (Commercial/Industrial Sites)",')
- CASE Comm3 == 'X'
- =FWRITE(new, '"Vacant Land (Residential Sites)",')
- CASE Comm3 == 'Y'
- =FWRITE(new, '"Real Estate Owned (REO)",')
- OTHERWISE
- =FWRITE(new, ',')
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(Comm4))
- DO CASE
- CASE Comm4 == 'A'
- =FWRITE(new, '"Apartment Buildings (under 100 units)",')
- CASE Comm4 == 'B'
- =FWRITE(new, '"Apartment Buildings (over 100 units)",')
- CASE Comm4 == 'C'
- =FWRITE(new, '"Build to Suit/Leaseback (under 100 units)",')
- CASE Comm4 == 'D'
- =FWRITE(new, '"Business Opportunities",')
- CASE Comm4 == 'E'
- =FWRITE(new, '"Condo Conversions",')
- CASE Comm4 == 'F'
- =FWRITE(new, '"Development",')
- CASE Comm4 == 'G'
- =FWRITE(new, '"Exchanging",')
- CASE Comm4 == 'H'
- =FWRITE(new, '"Farm and Land",')
- CASE Comm4 == 'I'
- =FWRITE(new, '"Foreign Investment Property",')
- CASE Comm4 == 'J'
- =FWRITE(new, '"General Commercial",')
- CASE Comm4 == 'K'
- =FWRITE(new, '"Health Care Faculties",')
- CASE Comm4 == 'L'
- =FWRITE(new, '"Hotels/Motels",')
- CASE Comm4 == 'M'
- =FWRITE(new, '"Industrial Properties/Warehouse",')
- CASE Comm4 == 'N'
- =FWRITE(new, '"Leasing",')
- CASE Comm4 == 'O'
- =FWRITE(new, '"Mobile Home Parks",')
- CASE Comm4 == 'P'
- =FWRITE(new, '"Office Buildings (under 100,000 S.F.)",')
- CASE Comm4 == 'Q'
- =FWRITE(new, '"Office Buildings (over 100,000 S.F.)",')
- CASE Comm4 == 'R'
- =FWRITE(new, '"Other",')
- CASE Comm4 == 'S'
- =FWRITE(new, '"Restaurant",')
- CASE Comm4 == 'T'
- =FWRITE(new, '"Retirement Properties/Communities",')
- CASE Comm4 == 'U'
- =FWRITE(new, '"Shopping Centers (under 100,000 S.F.)",')
- CASE Comm4 == 'V'
- =FWRITE(new, '"Shopping Centers (over 100,000 S.F.)",')
- CASE Comm4 == 'W'
- =FWRITE(new, '"Vacant Land (Commercial/Industrial Sites)",')
- CASE Comm4 == 'X'
- =FWRITE(new, '"Vacant Land (Residential Sites)",')
- CASE Comm4 == 'Y'
- =FWRITE(new, '"Real Estate Owned (REO)",')
- OTHERWISE
- =FWRITE(new, ',')
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(Comm5))
- DO CASE
- CASE Comm5 == 'A'
- =FWRITE(new, '"Apartment Buildings (under 100 units)",')
- CASE Comm5 == 'B'
- =FWRITE(new, '"Apartment Buildings (over 100 units)",')
- CASE Comm5 == 'C'
- =FWRITE(new, '"Build to Suit/Leaseback (under 100 units)",')
- CASE Comm5 == 'D'
- =FWRITE(new, '"Business Opportunities",')
- CASE Comm5 == 'E'
- =FWRITE(new, '"Condo Conversions",')
- CASE Comm5 == 'F'
- =FWRITE(new, '"Development",')
- CASE Comm5 == 'G'
- =FWRITE(new, '"Exchanging",')
- CASE Comm5 == 'H'
- =FWRITE(new, '"Farm and Land",')
- CASE Comm5 == 'I'
- =FWRITE(new, '"Foreign Investment Property",')
- CASE Comm5 == 'J'
- =FWRITE(new, '"General Commercial",')
- CASE Comm5 == 'K'
- =FWRITE(new, '"Health Care Faculties",')
- CASE Comm5 == 'L'
- =FWRITE(new, '"Hotels/Motels",')
- CASE Comm5 == 'M'
- =FWRITE(new, '"Industrial Properties/Warehouse",')
- CASE Comm5 == 'N'
- =FWRITE(new, '"Leasing",')
- CASE Comm5 == 'O'
- =FWRITE(new, '"Mobile Home Parks",')
- CASE Comm5 == 'P'
- =FWRITE(new, '"Office Buildings (under 100,000 S.F.)",')
- CASE Comm5 == 'Q'
- =FWRITE(new, '"Office Buildings (over 100,000 S.F.)",')
- CASE Comm5 == 'R'
- =FWRITE(new, '"Other",')
- CASE Comm5 == 'S'
- =FWRITE(new, '"Restaurant",')
- CASE Comm5 == 'T'
- =FWRITE(new, '"Retirement Properties/Communities",')
- CASE Comm5 == 'U'
- =FWRITE(new, '"Shopping Centers (under 100,000 S.F.)",')
- CASE Comm5 == 'V'
- =FWRITE(new, '"Shopping Centers (over 100,000 S.F.)",')
- CASE Comm5 == 'W'
- =FWRITE(new, '"Vacant Land (Commercial/Industrial Sites)",')
- CASE Comm5 == 'X'
- =FWRITE(new, '"Vacant Land (Residential Sites)",')
- CASE Comm5 == 'Y'
- =FWRITE(new, '"Real Estate Owned (REO)",')
- OTHERWISE
- =FWRITE(new, ',')
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(OffName))
- =FWRITE(new, '"'+TRIM(OffName)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(OffAdd1))
- =FWRITE(new, '"'+TRIM(OffAdd1)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(OffAdd2))
- =FWRITE(new, '"'+TRIM(OffAdd2)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(City))
- =FWRITE(new, '"'+TRIM(City)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(State))
- =FWRITE(new, '"'+UPPER(TRIM(State))+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Zip))
- =FWRITE(new, '"'+TRIM(Zip)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Country))
- =FWRITE(new, '"'+TRIM(Country)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Phone1))
- =FWRITE(new, '"'+TRIM(Phone1)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Phone2))
- =FWRITE(new, '"'+TRIM(Phone2)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Phone3))
- =FWRITE(new, '"'+TRIM(Phone3)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Phone4))
- =FWRITE(new, '"'+TRIM(Phone4)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(FAX))
- =FWRITE(new, '"'+TRIM(FAX)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Picture))
- =FWRITE(new, '"'+TRIM(Picture)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Service1))
- =FWRITE(new, '"'+TRIM(Service1)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Service2))
- =FWRITE(new, '"'+TRIM(Service2)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Service3))
- =FWRITE(new, '"'+TRIM(Service3)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Service4))
- =FWRITE(new, '"'+TRIM(Service4)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Open))
- =FWRITE(new, TRIM(Open)+',')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(ADI))
- =FWRITE(new, '"'+TRIM(ADI)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Page))
- =FWRITE(new, '"'+TRIM(Page)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Coor))
- =FWRITE(new, '"'+TRIM(Coor)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(OffType))
- =FWRITE(new, TRIM(OffType)+',')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(CityOver))
- =FWRITE(new, '"'+TRIM(CityOver)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(RosterSta))
- =FWRITE(new, '"'+TRIM(RosterSta)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Rams))
- =FWRITE(new, '"'+TRIM(Rams)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Achiev))
- =FWRITE(new, '"ACHIEV: '+TRIM(Achiev)+'",')
- ELSE
- =FWRITE(new, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(COMPUSERV))
- =FPUTS(new, ALLTRIM(COMPUSERV)+',')
- ELSE
- =FPUTS(new, ',')
- ENDIF
-
- * IF NOT EMPTY(TRIM(PICTURE))
- IF PICTURE == 'Y'
-
- =FWRITE(bio, Unique+',')
-
- IF NOT EMPTY(TRIM(PhoneLoc))
- =FWRITE(bio, '"'+TRIM(PhoneLoc)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(HomePhone))
- =FWRITE(bio, '"'+TRIM(HomePhone)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(AgntFax))
- =FWRITE(bio, '"'+TRIM(AgntFax)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(AgntPager))
- =FWRITE(bio, '"'+TRIM(AgntPager)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(AgntMobile))
- =FWRITE(bio, '"'+TRIM(AgntMobile)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(CIVIC1))
- DO CASE
- CASE CIVIC1 == 'AGED'
- =FWRITE(bio, '"Aged Volunteer",')
- CASE CIVIC1 == 'ALCO'
- =FWRITE(bio, '"AlcoholicsAnon/Al Anon",')
- CASE CIVIC1 == 'ARMD'
- =FWRITE(bio, '"Armed Forces Reserves",')
- CASE CIVIC1 == 'BATT'
- =FWRITE(bio, '"Battered/Sexual Abuse",')
- CASE CIVIC1 == 'BGCL'
- =FWRITE(bio, '"Boys/Girls Clubs",')
- CASE CIVIC1 == 'BGSC'
- =FWRITE(bio, '"Boy/Girl Scouts",')
- CASE CIVIC1 == 'BOAR'
- =FWRITE(bio, '"Board of Realtors",')
- CASE CIVIC1 == 'BUSW'
- =FWRITE(bio, '"Businesswomen's Clubs",')
- CASE CIVIC1 == 'CANC'
- =FWRITE(bio, '"Cancer Society",')
- CASE CIVIC1 == 'CARE'
- =FWRITE(bio, '"CARES",')
- CASE CIVIC1 == 'CIVI'
- =FWRITE(bio, '"Civic Activities",')
- CASE CIVIC1 == 'CF '
- =FWRITE(bio, '"Cystic Fibrosis",')
- CASE CIVIC1 == 'CCJC'
- =FWRITE(bio, '"Chamber of Commerce/Jaycees",')
- CASE CIVIC1 == 'CHSC'
- =FWRITE(bio, '"Church/School Volunteer",')
- CASE CIVIC1 == 'CMN '
- =FWRITE(bio, '"Children's Miracle Network",')
- CASE CIVIC1 == 'COAC'
- =FWRITE(bio, '"Coach Volunteer",')
- CASE CIVIC1 == 'COLL'
- =FWRITE(bio, '"College/Frat Alumni",')
- CASE CIVIC1 == 'COMM'
- =FWRITE(bio, '"Community Economic Devmt",')
- CASE CIVIC1 == 'CRSB'
- =FWRITE(bio, '"CRS/CRB",')
- CASE CIVIC1 == 'DELQ'
- =FWRITE(bio, '"Delinquency/Tough Love",')
- CASE CIVIC1 == 'EAST'
- =FWRITE(bio, '"Easter Seals/Handicapped",')
- CASE CIVIC1 == 'EEMC'
- =FWRITE(bio, '"Eagles/Elks/Moose Clubs",')
- CASE CIVIC1 == 'ENVR'
- =FWRITE(bio, '"Environmental Concerns",')
- CASE CIVIC1 == 'FOST'
- =FWRITE(bio, '"Foster Care/Adoption",')
- CASE CIVIC1 == 'GRPE'
- =FWRITE(bio, '"Green Peace",')
- CASE CIVIC1 == 'HOBL'
- =FWRITE(bio, '"Home Builders",')
- CASE CIVIC1 == 'HOLS'
- =FWRITE(bio, '"Homeless",')
- CASE CIVIC1 == 'HOME'
- =FWRITE(bio, '"Home Owners Association",')
- CASE CIVIC1 == 'HOSP'
- =FWRITE(bio, '"Hospital Volunteer",')
- CASE CIVIC1 == 'HUMA'
- =FWRITE(bio, '"Humane Society",')
- CASE CIVIC1 == 'JRLG'
- =FWRITE(bio, '"Jr. League",')
- CASE CIVIC1 == 'KIWA'
- =FWRITE(bio, '"Kiwanis",')
- CASE CIVIC1 == 'KNCO'
- =FWRITE(bio, '"Knights of Columbus",')
- CASE CIVIC1 == 'LION'
- =FWRITE(bio, '"Lions Clubs",')
- CASE CIVIC1 == 'LITL'
- =FWRITE(bio, '"Little League",')
- CASE CIVIC1 == 'MAKE'
- =FWRITE(bio, '"Make-A-Wish",')
- CASE CIVIC1 == 'MASO'
- =FWRITE(bio, '"Masons/Eastern Star/Shriners",')
- CASE CIVIC1 == 'MEAL'
- =FWRITE(bio, '"Meals on Wheels",')
- CASE CIVIC1 == 'MEDL'
- =FWRITE(bio, '"Medical Auxillary",')
- CASE CIVIC1 == 'MS '
- =FWRITE(bio, '"Multiple Sclerosis",')
- CASE CIVIC1 == 'OPT '
- =FWRITE(bio, '"Optimist",')
- CASE CIVIC1 == 'PTAO'
- =FWRITE(bio, '"PTA/PTO",')
- CASE CIVIC1 == 'POLI'
- =FWRITE(bio, '"Politics/Political Clubs",')
- CASE CIVIC1 == 'REDC'
- =FWRITE(bio, '"Red Cross",')
- CASE CIVIC1 == 'RETD'
- =FWRITE(bio, '"Retarded People",')
- CASE CIVIC1 == 'RONM'
- =FWRITE(bio, '"Ronald McDonald House",')
- CASE CIVIC1 == 'ROTY'
- =FWRITE(bio, '"Rotary",')
- CASE CIVIC1 == 'SADD'
- =FWRITE(bio, '"SADD/MADD",')
- CASE CIVIC1 == 'SIER'
- =FWRITE(bio, '"Sierra Club",')
- CASE CIVIC1 == 'SPOL'
- =FWRITE(bio, '"Special Olympics",')
- CASE CIVIC1 == 'STDY'
- =FWRITE(bio, '"Study Club",')
- CASE CIVIC1 == 'TOAS'
- =FWRITE(bio, '"Toastmasters",')
- CASE CIVIC1 == 'UNIT'
- =FWRITE(bio, '"United Way",')
- CASE CIVIC1 == 'VF '
- =FWRITE(bio, '"VFW/Am Legion",')
- CASE CIVIC1 == 'WC '
- =FWRITE(bio, '"Women's Council of Realtors",')
- CASE CIVIC1 == 'YMCA'
- =FWRITE(bio, '"YMCA/YWCA",')
- OTHERWISE
- =FWRITE(bio, ',')
- ENDCASE
- ENDIF
-
-
- IF NOT EMPTY(TRIM(CIVIC2))
- DO CASE
- CASE CIVIC2 == 'AGED'
- =FWRITE(bio, '"Aged Volunteer",')
- CASE CIVIC2 == 'ALCO'
- =FWRITE(bio, '"AlcoholicsAnon/Al Anon",')
- CASE CIVIC2 == 'ARMD'
- =FWRITE(bio, '"Armed Forces Reserves",')
- CASE CIVIC2 == 'BATT'
- =FWRITE(bio, '"Battered/Sexual Abuse",')
- CASE CIVIC2 == 'BGCL'
- =FWRITE(bio, '"Boys/Girls Clubs",')
- CASE CIVIC2 == 'BGSC'
- =FWRITE(bio, '"Boy/Girl Scouts",')
- CASE CIVIC2 == 'BOAR'
- =FWRITE(bio, '"Board of Realtors",')
- CASE CIVIC2 == 'BUSW'
- =FWRITE(bio, '"Businesswomen's Clubs",')
- CASE CIVIC2 == 'CANC'
- =FWRITE(bio, '"Cancer Society",')
- CASE CIVIC2 == 'CARE'
- =FWRITE(bio, '"CARES",')
- CASE CIVIC2 == 'CIVI'
- =FWRITE(bio, '"Civic Activities",')
- CASE CIVIC2 == 'CF '
- =FWRITE(bio, '"Cystic Fibrosis",')
- CASE CIVIC2 == 'CCJC'
- =FWRITE(bio, '"Chamber of Commerce/Jaycees",')
- CASE CIVIC2 == 'CHSC'
- =FWRITE(bio, '"Church/School Volunteer",')
- CASE CIVIC2 == 'CMN '
- =FWRITE(bio, '"Children's Miracle Network",')
- CASE CIVIC2 == 'COAC'
- =FWRITE(bio, '"Coach Volunteer",')
- CASE CIVIC2 == 'COLL'
- =FWRITE(bio, '"College/Frat Alumni",')
- CASE CIVIC2 == 'COMM'
- =FWRITE(bio, '"Community Economic Devmt",')
- CASE CIVIC2 == 'CRSB'
- =FWRITE(bio, '"CRS/CRB",')
- CASE CIVIC2 == 'DELQ'
- =FWRITE(bio, '"Delinquency/Tough Love",')
- CASE CIVIC2 == 'EAST'
- =FWRITE(bio, '"Easter Seals/Handicapped",')
- CASE CIVIC2 == 'EEMC'
- =FWRITE(bio, '"Eagles/Elks/Moose Clubs",')
- CASE CIVIC2 == 'ENVR'
- =FWRITE(bio, '"Environmental Concerns",')
- CASE CIVIC2 == 'FOST'
- =FWRITE(bio, '"Foster Care/Adoption",')
- CASE CIVIC2 == 'GRPE'
- =FWRITE(bio, '"Green Peace",')
- CASE CIVIC2 == 'HOBL'
- =FWRITE(bio, '"Home Builders",')
- CASE CIVIC2 == 'HOLS'
- =FWRITE(bio, '"Homeless",')
- CASE CIVIC2 == 'HOME'
- =FWRITE(bio, '"Home Owners Association",')
- CASE CIVIC2 == 'HOSP'
- =FWRITE(bio, '"Hospital Volunteer",')
- CASE CIVIC2 == 'HUMA'
- =FWRITE(bio, '"Humane Society",')
- CASE CIVIC2 == 'JRLG'
- =FWRITE(bio, '"Jr. League",')
- CASE CIVIC2 == 'KIWA'
- =FWRITE(bio, '"Kiwanis",')
- CASE CIVIC2 == 'KNCO'
- =FWRITE(bio, '"Knights of Columbus",')
- CASE CIVIC2 == 'LION'
- =FWRITE(bio, '"Lions Clubs",')
- CASE CIVIC2 == 'LITL'
- =FWRITE(bio, '"Little League",')
- CASE CIVIC2 == 'MAKE'
- =FWRITE(bio, '"Make-A-Wish",')
- CASE CIVIC2 == 'MASO'
- =FWRITE(bio, '"Masons/Eastern Star/Shriners",')
- CASE CIVIC2 == 'MEAL'
- =FWRITE(bio, '"Meals on Wheels",')
- CASE CIVIC2 == 'MEDL'
- =FWRITE(bio, '"Medical Auxillary",')
- CASE CIVIC2 == 'MS '
- =FWRITE(bio, '"Multiple Sclerosis",')
- CASE CIVIC2 == 'OPT '
- =FWRITE(bio, '"Optimist",')
- CASE CIVIC2 == 'PTAO'
- =FWRITE(bio, '"PTA/PTO",')
- CASE CIVIC2 == 'POLI'
- =FWRITE(bio, '"Politics/Political Clubs",')
- CASE CIVIC2 == 'REDC'
- =FWRITE(bio, '"Red Cross",')
- CASE CIVIC2 == 'RETD'
- =FWRITE(bio, '"Retarded People",')
- CASE CIVIC2 == 'RONM'
- =FWRITE(bio, '"Ronald McDonald House",')
- CASE CIVIC2 == 'ROTY'
- =FWRITE(bio, '"Rotary",')
- CASE CIVIC2 == 'SADD'
- =FWRITE(bio, '"SADD/MADD",')
- CASE CIVIC2 == 'SIER'
- =FWRITE(bio, '"Sierra Club",')
- CASE CIVIC2 == 'SPOL'
- =FWRITE(bio, '"Special Olympics",')
- CASE CIVIC2 == 'STDY'
- =FWRITE(bio, '"Study Club",')
- CASE CIVIC2 == 'TOAS'
- =FWRITE(bio, '"Toastmasters",')
- CASE CIVIC2 == 'UNIT'
- =FWRITE(bio, '"United Way",')
- CASE CIVIC2 == 'VF '
- =FWRITE(bio, '"VFW/Am Legion",')
- CASE CIVIC2 == 'WC '
- =FWRITE(bio, '"Women's Council of Realtors",')
- CASE CIVIC2 == 'YMCA'
- =FWRITE(bio, '"YMCA/YWCA",')
- OTHERWISE
- =FWRITE(bio, ',')
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(CIVIC1))
- DO CASE
- CASE CIVIC3 == 'AGED'
- =FWRITE(bio, '"Aged Volunteer",')
- CASE CIVIC3 == 'ALCO'
- =FWRITE(bio, '"AlcoholicsAnon/Al Anon",')
- CASE CIVIC3 == 'ARMD'
- =FWRITE(bio, '"Armed Forces Reserves",')
- CASE CIVIC3 == 'BATT'
- =FWRITE(bio, '"Battered/Sexual Abuse",')
- CASE CIVIC3 == 'BGCL'
- =FWRITE(bio, '"Boys/Girls Clubs",')
- CASE CIVIC3 == 'BGSC'
- =FWRITE(bio, '"Boy/Girl Scouts",')
- CASE CIVIC3 == 'BOAR'
- =FWRITE(bio, '"Board of Realtors",')
- CASE CIVIC3 == 'BUSW'
- =FWRITE(bio, '"Businesswomen's Clubs",')
- CASE CIVIC3 == 'CANC'
- =FWRITE(bio, '"Cancer Society",')
- CASE CIVIC3 == 'CARE'
- =FWRITE(bio, '"CARES",')
- CASE CIVIC3 == 'CIVI'
- =FWRITE(bio, '"Civic Activities",')
- CASE CIVIC3 == 'CF '
- =FWRITE(bio, '"Cystic Fibrosis",')
- CASE CIVIC3 == 'CCJC'
- =FWRITE(bio, '"Chamber of Commerce/Jaycees",')
- CASE CIVIC3 == 'CHSC'
- =FWRITE(bio, '"Church/School Volunteer",')
- CASE CIVIC3 == 'CMN '
- =FWRITE(bio, '"Children's Miracle Network",')
- CASE CIVIC3 == 'COAC'
- =FWRITE(bio, '"Coach Volunteer",')
- CASE CIVIC3 == 'COLL'
- =FWRITE(bio, '"College/Frat Alumni",')
- CASE CIVIC3 == 'COMM'
- =FWRITE(bio, '"Community Economic Devmt",')
- CASE CIVIC3 == 'CRSB'
- =FWRITE(bio, '"CRS/CRB",')
- CASE CIVIC3 == 'DELQ'
- =FWRITE(bio, '"Delinquency/Tough Love",')
- CASE CIVIC3 == 'EAST'
- =FWRITE(bio, '"Easter Seals/Handicapped",')
- CASE CIVIC3 == 'EEMC'
- =FWRITE(bio, '"Eagles/Elks/Moose Clubs",')
- CASE CIVIC3 == 'ENVR'
- =FWRITE(bio, '"Environmental Concerns",')
- CASE CIVIC3 == 'FOST'
- =FWRITE(bio, '"Foster Care/Adoption",')
- CASE CIVIC3 == 'GRPE'
- =FWRITE(bio, '"Green Peace",')
- CASE CIVIC3 == 'HOBL'
- =FWRITE(bio, '"Home Builders",')
- CASE CIVIC3 == 'HOLS'
- =FWRITE(bio, '"Homeless",')
- CASE CIVIC3 == 'HOME'
- =FWRITE(bio, '"Home Owners Association",')
- CASE CIVIC3 == 'HOSP'
- =FWRITE(bio, '"Hospital Volunteer",')
- CASE CIVIC3 == 'HUMA'
- =FWRITE(bio, '"Humane Society",')
- CASE CIVIC3 == 'JRLG'
- =FWRITE(bio, '"Jr. League",')
- CASE CIVIC3 == 'KIWA'
- =FWRITE(bio, '"Kiwanis",')
- CASE CIVIC3 == 'KNCO'
- =FWRITE(bio, '"Knights of Columbus",')
- CASE CIVIC3 == 'LION'
- =FWRITE(bio, '"Lions Clubs",')
- CASE CIVIC3 == 'LITL'
- =FWRITE(bio, '"Little League",')
- CASE CIVIC3 == 'MAKE'
- =FWRITE(bio, '"Make-A-Wish",')
- CASE CIVIC3 == 'MASO'
- =FWRITE(bio, '"Masons/Eastern Star/Shriners",')
- CASE CIVIC3 == 'MEAL'
- =FWRITE(bio, '"Meals on Wheels",')
- CASE CIVIC3 == 'MEDL'
- =FWRITE(bio, '"Medical Auxillary",')
- CASE CIVIC3 == 'MS '
- =FWRITE(bio, '"Multiple Sclerosis",')
- CASE CIVIC3 == 'OPT '
- =FWRITE(bio, '"Optimist",')
- CASE CIVIC3 == 'PTAO'
- =FWRITE(bio, '"PTA/PTO",')
- CASE CIVIC3 == 'POLI'
- =FWRITE(bio, '"Politics/Political Clubs",')
- CASE CIVIC3 == 'REDC'
- =FWRITE(bio, '"Red Cross",')
- CASE CIVIC3 == 'RETD'
- =FWRITE(bio, '"Retarded People",')
- CASE CIVIC3 == 'RONM'
- =FWRITE(bio, '"Ronald McDonald House",')
- CASE CIVIC3 == 'ROTY'
- =FWRITE(bio, '"Rotary",')
- CASE CIVIC3 == 'SADD'
- =FWRITE(bio, '"SADD/MADD",')
- CASE CIVIC3 == 'SIER'
- =FWRITE(bio, '"Sierra Club",')
- CASE CIVIC3 == 'SPOL'
- =FWRITE(bio, '"Special Olympics",')
- CASE CIVIC3 == 'STDY'
- =FWRITE(bio, '"Study Club",')
- CASE CIVIC3 == 'TOAS'
- =FWRITE(bio, '"Toastmasters",')
- CASE CIVIC3 == 'UNIT'
- =FWRITE(bio, '"United Way",')
- CASE CIVIC3 == 'VF '
- =FWRITE(bio, '"VFW/Am Legion",')
- CASE CIVIC3 == 'WC '
- =FWRITE(bio, '"Women's Council of Realtors",')
- CASE CIVIC3 == 'YMCA'
- =FWRITE(bio, '"YMCA/YWCA",')
- OTHERWISE
- =FWRITE(bio, ',')
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(HOBBY1))
- DO CASE
-
- CASE HOBBY1 == 'ANTC'
- =FWRITE(bio, '"Antique Cars",')
- CASE HOBBY1 == 'ANTQ'
- =FWRITE(bio, '"Antiques",')
- CASE HOBBY1 == 'ARCH'
- =FWRITE(bio, '"Architecture",')
- CASE HOBBY1 == 'ART '
- =FWRITE(bio, '"Art/Painting",')
- CASE HOBBY1 == 'AUTO'
- =FWRITE(bio, '"Auto Racing",')
- CASE HOBBY1 == 'BASK'
- =FWRITE(bio, '"Basketball",')
- CASE HOBBY1 == 'BILL'
- =FWRITE(bio, '"Billiards",')
- CASE HOBBY1 == 'BIKE'
- =FWRITE(bio, '"Biking",')
- CASE HOBBY1 == 'BIRD'
- =FWRITE(bio, '"Bird Watching/Audubon",')
- CASE HOBBY1 == 'BOAT'
- =FWRITE(bio, '"Boating/Sailing",')
- CASE HOBBY1 == 'BOWL'
- =FWRITE(bio, '"Bowling",')
- CASE HOBBY1 == 'BRID'
- =FWRITE(bio, '"Bridge",')
- CASE HOBBY1 == 'CHOR'
- =FWRITE(bio, '"Choir/Singing",')
- CASE HOBBY1 == 'CHRK'
- =FWRITE(bio, '"Chess/Checkers/Games",')
- CASE HOBBY1 == 'COLL'
- =FWRITE(bio, '"Collecting",')
- CASE HOBBY1 == 'COMP'
- =FWRITE(bio, '"Computers",')
- CASE HOBBY1 == 'COOK'
- =FWRITE(bio, '"Cooking",')
- CASE HOBBY1 == 'CURL'
- =FWRITE(bio, '"Curling",')
- CASE HOBBY1 == 'DANC'
- =FWRITE(bio, '"Dancing",')
- CASE HOBBY1 == 'DOGS'
- =FWRITE(bio, '"Dogs/Cats",')
- CASE HOBBY1 == 'DRAM'
- =FWRITE(bio, '"Drama Groups",')
- CASE HOBBY1 == 'EDUC'
- =FWRITE(bio, '"Education/Training/Growth",')
- CASE HOBBY1 == 'FARM'
- =FWRITE(bio, '"Farming",')
- CASE HOBBY1 == 'FITN'
- =FWRITE(bio, '"Fitness",')
- CASE HOBBY1 == 'FLY '
- =FWRITE(bio, '"Flying",')
- CASE HOBBY1 == 'FOOD'
- =FWRITE(bio, '"Food/Wine",')
- CASE HOBBY1 == 'GAMB'
- =FWRITE(bio, '"Gambling",')
- CASE HOBBY1 == 'GARD'
- =FWRITE(bio, '"Gardening",')
- CASE HOBBY1 == 'GOLF'
- =FWRITE(bio, '"Golf",')
- CASE HOBBY1 == 'HIKE'
- =FWRITE(bio, '"Hiking/Camping",')
- CASE HOBBY1 == 'HIST'
- =FWRITE(bio, '"Historical Society",')
- CASE HOBBY1 == 'HOCK'
- =FWRITE(bio, '"Hockey",')
- CASE HOBBY1 == 'HORS'
- =FWRITE(bio, '"Horses",')
- CASE HOBBY1 == 'HOT '
- =FWRITE(bio, '"Hot Air Ballooning",')
- CASE HOBBY1 == 'HUNT'
- =FWRITE(bio, '"Hunt/Fish",')
- CASE HOBBY1 == 'INDE'
- =FWRITE(bio, '"Interior Decorating",')
- CASE HOBBY1 == 'MART'
- =FWRITE(bio, '"Martial Arts",')
- CASE HOBBY1 == 'MODL'
- =FWRITE(bio, '"Model Planes/Trains",')
- CASE HOBBY1 == 'MOTO'
- =FWRITE(bio, '"Motorcycles",')
- CASE HOBBY1 == 'MUIN'
- =FWRITE(bio, '"Musical Instruments",')
- CASE HOBBY1 == 'MUSE'
- =FWRITE(bio, '"Museums",')
- CASE HOBBY1 == 'MUSI'
- =FWRITE(bio, '"Music/Opera/Ballet/Symphony",')
- CASE HOBBY1 == 'PHOT'
- =FWRITE(bio, '"Photography",')
- CASE HOBBY1 == 'READ'
- =FWRITE(bio, '"Reading",')
- CASE HOBBY1 == 'SCUB'
- =FWRITE(bio, '"Scuba/Snorkel",')
- CASE HOBBY1 == 'SEW '
- =FWRITE(bio, '"Sewing/Needlecraft/Quilting",')
- CASE HOBBY1 == 'SHOP'
- =FWRITE(bio, '"Shoppping",')
- CASE HOBBY1 == 'SHOT'
- =FWRITE(bio, '"Target/Trap Shooting",')
- CASE HOBBY1 == 'SNOM'
- =FWRITE(bio, '"Snowmobiling",')
- CASE HOBBY1 == 'SNOS'
- =FWRITE(bio, '"Snowskiing",')
- CASE HOBBY1 == 'SOCC'
- =FWRITE(bio, '"Soccer",')
- CASE HOBBY1 == 'SOFT'
- =FWRITE(bio, '"Softball",')
- CASE HOBBY1 == 'SPEC'
- =FWRITE(bio, '"Spectator Sports",')
- CASE HOBBY1 == 'SQUA'
- =FWRITE(bio, '"Squash",')
- CASE HOBBY1 == 'STGL'
- =FWRITE(bio, '"Stained Glass",')
- CASE HOBBY1 == 'SWIM'
- =FWRITE(bio, '"Swimming",')
- CASE HOBBY1 == 'TENN'
- =FWRITE(bio, '"Tennis",')
- CASE HOBBY1 == 'THEA'
- =FWRITE(bio, '"Theatre/Movies",')
- CASE HOBBY1 == 'TRAV'
- =FWRITE(bio, '"Travel",')
- CASE HOBBY1 == 'VOLL'
- =FWRITE(bio, '"Volleyball",')
- CASE HOBBY1 == 'WATS'
- =FWRITE(bio, '"Water Skiing",')
- CASE HOBBY1 == 'WELF'
- =FWRITE(bio, '"Weightlifting",')
- CASE HOBBY1 == 'WOOD'
- =FWRITE(bio, '"Woodworking",')
- CASE HOBBY1 == 'WRIT'
- =FWRITE(bio, '"Writing",')
- CASE HOBBY1 == 'YOGA'
- =FWRITE(bio, '"Yoga/Meditation",')
- OTHERWISE
- =FWRITE(bio, ',')
-
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(HOBBY2))
- DO CASE
-
- CASE HOBBY2 == 'ANTC'
- =FWRITE(bio, '"Antique Cars",')
- CASE HOBBY2 == 'ANTQ'
- =FWRITE(bio, '"Antiques",')
- CASE HOBBY2 == 'ARCH'
- =FWRITE(bio, '"Architecture",')
- CASE HOBBY2 == 'ART '
- =FWRITE(bio, '"Art/Painting",')
- CASE HOBBY2 == 'AUTO'
- =FWRITE(bio, '"Auto Racing",')
- CASE HOBBY2 == 'BASK'
- =FWRITE(bio, '"Basketball",')
- CASE HOBBY2 == 'BILL'
- =FWRITE(bio, '"Billiards",')
- CASE HOBBY2 == 'BIKE'
- =FWRITE(bio, '"Biking",')
- CASE HOBBY2 == 'BIRD'
- =FWRITE(bio, '"Bird Watching/Audubon",')
- CASE HOBBY2 == 'BOAT'
- =FWRITE(bio, '"Boating/Sailing",')
- CASE HOBBY2 == 'BOWL'
- =FWRITE(bio, '"Bowling",')
- CASE HOBBY2 == 'BRID'
- =FWRITE(bio, '"Bridge",')
- CASE HOBBY2 == 'CHOR'
- =FWRITE(bio, '"Choir/Singing",')
- CASE HOBBY2 == 'CHRK'
- =FWRITE(bio, '"Chess/Checkers/Games",')
- CASE HOBBY2 == 'COLL'
- =FWRITE(bio, '"Collecting",')
- CASE HOBBY2 == 'COMP'
- =FWRITE(bio, '"Computers",')
- CASE HOBBY2 == 'COOK'
- =FWRITE(bio, '"Cooking",')
- CASE HOBBY2 == 'CURL'
- =FWRITE(bio, '"Curling",')
- CASE HOBBY2 == 'DANC'
- =FWRITE(bio, '"Dancing",')
- CASE HOBBY2 == 'DOGS'
- =FWRITE(bio, '"Dogs/Cats",')
- CASE HOBBY2 == 'DRAM'
- =FWRITE(bio, '"Drama Groups",')
- CASE HOBBY2 == 'EDUC'
- =FWRITE(bio, '"Education/Training/Growth",')
- CASE HOBBY2 == 'FARM'
- =FWRITE(bio, '"Farming",')
- CASE HOBBY2 == 'FITN'
- =FWRITE(bio, '"Fitness",')
- CASE HOBBY2 == 'FLY '
- =FWRITE(bio, '"Flying",')
- CASE HOBBY2 == 'FOOD'
- =FWRITE(bio, '"Food/Wine",')
- CASE HOBBY2 == 'GAMB'
- =FWRITE(bio, '"Gambling",')
- CASE HOBBY2 == 'GARD'
- =FWRITE(bio, '"Gardening",')
- CASE HOBBY2 == 'GOLF'
- =FWRITE(bio, '"Golf",')
- CASE HOBBY2 == 'HIKE'
- =FWRITE(bio, '"Hiking/Camping",')
- CASE HOBBY2 == 'HIST'
- =FWRITE(bio, '"Historical Society",')
- CASE HOBBY2 == 'HOCK'
- =FWRITE(bio, '"Hockey",')
- CASE HOBBY2 == 'HORS'
- =FWRITE(bio, '"Horses",')
- CASE HOBBY2 == 'HOT '
- =FWRITE(bio, '"Hot Air Ballooning",')
- CASE HOBBY2 == 'HUNT'
- =FWRITE(bio, '"Hunt/Fish",')
- CASE HOBBY2 == 'INDE'
- =FWRITE(bio, '"Interior Decorating",')
- CASE HOBBY2 == 'MART'
- =FWRITE(bio, '"Martial Arts",')
- CASE HOBBY2 == 'MODL'
- =FWRITE(bio, '"Model Planes/Trains",')
- CASE HOBBY2 == 'MOTO'
- =FWRITE(bio, '"Motorcycles",')
- CASE HOBBY2 == 'MUIN'
- =FWRITE(bio, '"Musical Instruments",')
- CASE HOBBY2 == 'MUSE'
- =FWRITE(bio, '"Museums",')
- CASE HOBBY2 == 'MUSI'
- =FWRITE(bio, '"Music/Opera/Ballet/Symphony",')
- CASE HOBBY2 == 'PHOT'
- =FWRITE(bio, '"Photography",')
- CASE HOBBY2 == 'READ'
- =FWRITE(bio, '"Reading",')
- CASE HOBBY2 == 'SCUB'
- =FWRITE(bio, '"Scuba/Snorkel",')
- CASE HOBBY2 == 'SEW '
- =FWRITE(bio, '"Sewing/Needlecraft/Quilting",')
- CASE HOBBY2 == 'SHOP'
- =FWRITE(bio, '"Shoppping",')
- CASE HOBBY2 == 'SHOT'
- =FWRITE(bio, '"Target/Trap Shooting",')
- CASE HOBBY2 == 'SNOM'
- =FWRITE(bio, '"Snowmobiling",')
- CASE HOBBY2 == 'SNOS'
- =FWRITE(bio, '"Snowskiing",')
- CASE HOBBY2 == 'SOCC'
- =FWRITE(bio, '"Soccer",')
- CASE HOBBY2 == 'SOFT'
- =FWRITE(bio, '"Softball",')
- CASE HOBBY2 == 'SPEC'
- =FWRITE(bio, '"Spectator Sports",')
- CASE HOBBY2 == 'SQUA'
- =FWRITE(bio, '"Squash",')
- CASE HOBBY2 == 'STGL'
- =FWRITE(bio, '"Stained Glass",')
- CASE HOBBY2 == 'SWIM'
- =FWRITE(bio, '"Swimming",')
- CASE HOBBY2 == 'TENN'
- =FWRITE(bio, '"Tennis",')
- CASE HOBBY2 == 'THEA'
- =FWRITE(bio, '"Theatre/Movies",')
- CASE HOBBY2 == 'TRAV'
- =FWRITE(bio, '"Travel",')
- CASE HOBBY2 == 'VOLL'
- =FWRITE(bio, '"Volleyball",')
- CASE HOBBY2 == 'WATS'
- =FWRITE(bio, '"Water Skiing",')
- CASE HOBBY2 == 'WELF'
- =FWRITE(bio, '"Weightlifting",')
- CASE HOBBY2 == 'WOOD'
- =FWRITE(bio, '"Woodworking",')
- CASE HOBBY2 == 'WRIT'
- =FWRITE(bio, '"Writing",')
- CASE HOBBY2 == 'YOGA'
- =FWRITE(bio, '"Yoga/Meditation",')
- OTHERWISE
- =FWRITE(bio, ',')
-
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(HOBBY3))
- DO CASE
-
- CASE HOBBY3 == 'ANTC'
- =FWRITE(bio, '"Antique Cars",')
- CASE HOBBY3 == 'ANTQ'
- =FWRITE(bio, '"Antiques",')
- CASE HOBBY3 == 'ARCH'
- =FWRITE(bio, '"Architecture",')
- CASE HOBBY3 == 'ART '
- =FWRITE(bio, '"Art/Painting",')
- CASE HOBBY3 == 'AUTO'
- =FWRITE(bio, '"Auto Racing",')
- CASE HOBBY3 == 'BASK'
- =FWRITE(bio, '"Basketball",')
- CASE HOBBY3 == 'BILL'
- =FWRITE(bio, '"Billiards",')
- CASE HOBBY3 == 'BIKE'
- =FWRITE(bio, '"Biking",')
- CASE HOBBY3 == 'BIRD'
- =FWRITE(bio, '"Bird Watching/Audubon",')
- CASE HOBBY3 == 'BOAT'
- =FWRITE(bio, '"Boating/Sailing",')
- CASE HOBBY3 == 'BOWL'
- =FWRITE(bio, '"Bowling",')
- CASE HOBBY3 == 'BRID'
- =FWRITE(bio, '"Bridge",')
- CASE HOBBY3 == 'CHOR'
- =FWRITE(bio, '"Choir/Singing",')
- CASE HOBBY3 == 'CHRK'
- =FWRITE(bio, '"Chess/Checkers/Games",')
- CASE HOBBY3 == 'COLL'
- =FWRITE(bio, '"Collecting",')
- CASE HOBBY3 == 'COMP'
- =FWRITE(bio, '"Computers",')
- CASE HOBBY3 == 'COOK'
- =FWRITE(bio, '"Cooking",')
- CASE HOBBY3 == 'CURL'
- =FWRITE(bio, '"Curling",')
- CASE HOBBY3 == 'DANC'
- =FWRITE(bio, '"Dancing",')
- CASE HOBBY3 == 'DOGS'
- =FWRITE(bio, '"Dogs/Cats",')
- CASE HOBBY3 == 'DRAM'
- =FWRITE(bio, '"Drama Groups",')
- CASE HOBBY3 == 'EDUC'
- =FWRITE(bio, '"Education/Training/Growth",')
- CASE HOBBY3 == 'FARM'
- =FWRITE(bio, '"Farming",')
- CASE HOBBY3 == 'FITN'
- =FWRITE(bio, '"Fitness",')
- CASE HOBBY3 == 'FLY '
- =FWRITE(bio, '"Flying",')
- CASE HOBBY3 == 'FOOD'
- =FWRITE(bio, '"Food/Wine",')
- CASE HOBBY3 == 'GAMB'
- =FWRITE(bio, '"Gambling",')
- CASE HOBBY3 == 'GARD'
- =FWRITE(bio, '"Gardening",')
- CASE HOBBY3 == 'GOLF'
- =FWRITE(bio, '"Golf",')
- CASE HOBBY3 == 'HIKE'
- =FWRITE(bio, '"Hiking/Camping",')
- CASE HOBBY3 == 'HIST'
- =FWRITE(bio, '"Historical Society",')
- CASE HOBBY3 == 'HOCK'
- =FWRITE(bio, '"Hockey",')
- CASE HOBBY3 == 'HORS'
- =FWRITE(bio, '"Horses",')
- CASE HOBBY3 == 'HOT '
- =FWRITE(bio, '"Hot Air Ballooning",')
- CASE HOBBY3 == 'HUNT'
- =FWRITE(bio, '"Hunt/Fish",')
- CASE HOBBY3 == 'INDE'
- =FWRITE(bio, '"Interior Decorating",')
- CASE HOBBY3 == 'MART'
- =FWRITE(bio, '"Martial Arts",')
- CASE HOBBY3 == 'MODL'
- =FWRITE(bio, '"Model Planes/Trains",')
- CASE HOBBY3 == 'MOTO'
- =FWRITE(bio, '"Motorcycles",')
- CASE HOBBY3 == 'MUIN'
- =FWRITE(bio, '"Musical Instruments",')
- CASE HOBBY3 == 'MUSE'
- =FWRITE(bio, '"Museums",')
- CASE HOBBY3 == 'MUSI'
- =FWRITE(bio, '"Music/Opera/Ballet/Symphony",')
- CASE HOBBY3 == 'PHOT'
- =FWRITE(bio, '"Photography",')
- CASE HOBBY3 == 'READ'
- =FWRITE(bio, '"Reading",')
- CASE HOBBY3 == 'SCUB'
- =FWRITE(bio, '"Scuba/Snorkel",')
- CASE HOBBY3 == 'SEW '
- =FWRITE(bio, '"Sewing/Needlecraft/Quilting",')
- CASE HOBBY3 == 'SHOP'
- =FWRITE(bio, '"Shoppping",')
- CASE HOBBY3 == 'SHOT'
- =FWRITE(bio, '"Target/Trap Shooting",')
- CASE HOBBY3 == 'SNOM'
- =FWRITE(bio, '"Snowmobiling",')
- CASE HOBBY3 == 'SNOS'
- =FWRITE(bio, '"Snowskiing",')
- CASE HOBBY3 == 'SOCC'
- =FWRITE(bio, '"Soccer",')
- CASE HOBBY3 == 'SOFT'
- =FWRITE(bio, '"Softball",')
- CASE HOBBY3 == 'SPEC'
- =FWRITE(bio, '"Spectator Sports",')
- CASE HOBBY3 == 'SQUA'
- =FWRITE(bio, '"Squash",')
- CASE HOBBY3 == 'STGL'
- =FWRITE(bio, '"Stained Glass",')
- CASE HOBBY3 == 'SWIM'
- =FWRITE(bio, '"Swimming",')
- CASE HOBBY3 == 'TENN'
- =FWRITE(bio, '"Tennis",')
- CASE HOBBY3 == 'THEA'
- =FWRITE(bio, '"Theatre/Movies",')
- CASE HOBBY3 == 'TRAV'
- =FWRITE(bio, '"Travel",')
- CASE HOBBY3 == 'VOLL'
- =FWRITE(bio, '"Volleyball",')
- CASE HOBBY3 == 'WATS'
- =FWRITE(bio, '"Water Skiing",')
- CASE HOBBY3 == 'WELF'
- =FWRITE(bio, '"Weightlifting",')
- CASE HOBBY3 == 'WOOD'
- =FWRITE(bio, '"Woodworking",')
- CASE HOBBY3 == 'WRIT'
- =FWRITE(bio, '"Writing",')
- CASE HOBBY3 == 'YOGA'
- =FWRITE(bio, '"Yoga/Meditation",')
- OTHERWISE
- =FWRITE(bio, ',')
-
- ENDCASE
- ENDIF
-
- IF NOT EMPTY(TRIM(MEMBER1))
- =FWRITE(bio, '"'+TRIM(MEMBER1)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(MEMBER2))
- =FWRITE(bio, '"'+TRIM(MEMBER2)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(MEMBER3))
- =FWRITE(bio, '"'+TRIM(MEMBER3)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Service1))
- =FWRITE(bio, '"'+TRIM(Service1)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Service2))
- =FWRITE(bio, '"'+TRIM(Service2)+'",')
- ELSE
- =FWRITE(bio, ',')
-
- ENDIF
-
- IF NOT EMPTY(TRIM(Service3))
- =FWRITE(bio, '"'+TRIM(Service3)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Service4))
- =FWRITE(bio, '"'+TRIM(Service4)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Service5))
- =FWRITE(bio, '"'+TRIM(Service5)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Education))
- =FWRITE(bio, '"'+TRIM(Education)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig1))
- =FWRITE(bio, '"'+TRIM(Desig1)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig2))
- =FWRITE(bio, '"'+TRIM(Desig2)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Desig3))
- =FWRITE(bio, '"'+TRIM(Desig3)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Career))
- =FWRITE(bio, '"'+TRIM(Career)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Price_fr))
- =FWRITE(bio, '"'+TRIM(Price_fr)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Price_to))
- =FWRITE(bio, '"'+TRIM(Price_to)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Pref))
- =FWRITE(bio, '"'+TRIM(Pref)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Referal1))
- =FWRITE(bio, '"'+TRIM(Referal1)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Referal2))
- =FWRITE(bio, '"'+TRIM(Referal2)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Referal3))
- =FWRITE(bio, '"'+TRIM(Referal3)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Referal4))
- =FWRITE(bio, '"'+TRIM(Referal4)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(ERCPaper))
- =FWRITE(bio, '"'+TRIM(ERCPaper)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Welcomekit))
- =FWRITE(bio, '"'+TRIM(Welcomekit)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Relocations))
- =FWRITE(bio, TRIM(Relocations)+',')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Picture))
- =FWRITE(bio, '"'+TRIM(Picture)+'",')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(EntryDate))
- =FWRITE(bio, TRIM(EntryDate)+',')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(BioSubs))
- =FWRITE(bio, TRIM(BioSubs)+',')
- ELSE
- =FWRITE(bio, ',')
- ENDIF
-
- IF NOT EMPTY(TRIM(Info))
- =FPUTS(bio, '"'+TRIM(Info)+'",')
- ELSE
- =FPUTS(bio, ',')
- ENDIF
-
- ENDIF
-
- * ENDIF
-
-
- Count = Count + 1
-
- * ? Relocations
- * ? EntryDate
- * ? Info
- * ? Picture
-
- ENDDO
-
- =FCLOSE(bio)
- =FCLOSE(handle)
- =FCLOSE(new)
-